package com.ourteam.workspace.dao;

import java.util.Arrays;
import java.util.List;
import java.util.Map;
import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;
import org.apache.commons.lang.StringUtils;

/**
 * Template Name : DAO查询对象 Template Version : 1 Template Last Modfiy Date : Sat Aug 19 10:06:32 CST
 * 2017 Auto Generate Date : 2018-11-30 18:42:30 Warning ! This file will be overwrite when
 * regenerate !
 */
public class ProjectServerRelateDAOQueryBean extends BaseQueryBean {

  public ProjectServerRelateDAOQueryBean() {
    super();
  }

  public ProjectServerRelateDAOQueryBean(BaseQueryBean aQueryBean) {
    super(aQueryBean);
  }

  public ProjectServerRelateDAOQueryBean(BaseQueryBean aQueryBean, Map tableReplaceMap) {
    super(aQueryBean, tableReplaceMap);
  }

  public Criteria createCriteria() {

    Criteria criteria = createCriteriaInternal();
    if (oredCriteria.size() == 0) {
      oredCriteria.add(criteria);
    }
    return criteria;
  }

  protected Criteria createCriteriaInternal() {
    return new Criteria(this);
  }

  public void addIdSelectProperty() {
    addIdSelectProperty("id");
  }

  public void addIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProjectServerRelateDAO.Id, aAlias);
    } else {
      addSelectProperty(IProjectServerRelateDAO.Id, "id");
    }
  }

  public void addMiddleWareIdSelectProperty() {
    addMiddleWareIdSelectProperty("middleWareId");
  }

  public void addMiddleWareIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProjectServerRelateDAO.MiddleWareId, aAlias);
    } else {
      addSelectProperty(IProjectServerRelateDAO.MiddleWareId, "middleWareId");
    }
  }

  public void addProjectIdSelectProperty() {
    addProjectIdSelectProperty("projectId");
  }

  public void addProjectIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProjectServerRelateDAO.ProjectId, aAlias);
    } else {
      addSelectProperty(IProjectServerRelateDAO.ProjectId, "projectId");
    }
  }

  public void addStatusSelectProperty() {
    addStatusSelectProperty("status");
  }

  public void addStatusSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IProjectServerRelateDAO.Status, aAlias);
    } else {
      addSelectProperty(IProjectServerRelateDAO.Status, "status");
    }
  }

  public void addAllSelectProperties() {

    addIdSelectProperty();

    addMiddleWareIdSelectProperty();

    addProjectIdSelectProperty();

    addStatusSelectProperty();
  }

  public static class Criteria extends BaseWhereCriterion<ProjectServerRelateDAOQueryBean> {

    protected Criteria(ProjectServerRelateDAOQueryBean aParentObject) {
      super(aParentObject);
    }

    public Criteria andIdIsNull() {
      addCriterion(IProjectServerRelateDAO.Id + " is null");
      return this;
    }

    public Criteria andIdIsNotNull() {
      addCriterion(IProjectServerRelateDAO.Id + " is not null");
      return this;
    }

    public Criteria andIdIsNotEmpty() {
      addCriterion(
          IProjectServerRelateDAO.Id + " is not null AND " + IProjectServerRelateDAO.Id + " <> ''");
      return this;
    }

    public Criteria andIdIsEmpty() {
      addCriterion(
          "("
              + IProjectServerRelateDAO.Id
              + " is null OR "
              + IProjectServerRelateDAO.Id
              + " = '')");
      return this;
    }

    public Criteria andIdEqualTo(long value) {
      return andIdEqualTo(Long.valueOf(value));
    }

    public Criteria andIdEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.Id + " = ", value, "id");
      return this;
    }

    public Criteria andIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Id);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Id + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdNotEqualTo(long value) {
      return andIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andIdNotEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.Id + " <>", value, "id");
      return this;
    }

    public Criteria andIdNotEqualToOrIsNull(long value) {
      return andIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IProjectServerRelateDAO.Id + " is null OR " + IProjectServerRelateDAO.Id + " <>",
          value,
          "id");
      return this;
    }

    public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Id);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Id + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdGreaterThan(long value) {
      return andIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andIdGreaterThan(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.Id + " >", value, "id");
      return this;
    }

    public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Id);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdGreaterThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Id + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdGreaterThanOrEqualTo(long value) {
      return andIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.Id + " >=", value, "id");
      return this;
    }

    public Criteria andIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Id);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Id + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdLessThan(long value) {
      return andIdLessThan(Long.valueOf(value));
    }

    public Criteria andIdLessThan(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.Id + " <", value, "id");
      return this;
    }

    public Criteria andIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Id);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Id + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdLessThanOrEqualTo(long value) {
      return andIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.Id + " <=", value, "id");
      return this;
    }

    public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Id);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Id + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdIn(long[] values) {
      if (values.length == 1) {
        return andIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.Id + " in", values, "id");
        return this;
      }
    }

    public Criteria andIdNotIn(long[] values) {
      if (values.length == 1) {
        return andIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.Id + " not in", values, "id");
        return this;
      }
    }

    public Criteria andIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andIdEqualTo(values.get(0));
      } else {
        addCriterion(IProjectServerRelateDAO.Id + " in", values, "id");
        return this;
      }
    }

    public Criteria andIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IProjectServerRelateDAO.Id + " not in", values, "id");
        return this;
      }
    }

    public Criteria andIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andIdEqualTo(values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.Id + " in", Arrays.asList(values), "id");
        return this;
      }
    }

    public Criteria andIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andIdNotEqualTo(values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.Id + " not in", Arrays.asList(values), "id");
        return this;
      }
    }

    public Criteria andIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Id + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Id + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdBetween(long value1, long value2) {
      addCriterion(IProjectServerRelateDAO.Id + " between", value1, value2, "id");
      return this;
    }

    public Criteria andIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProjectServerRelateDAO.Id + " between", value1, value2, "id");
      return this;
    }

    public Criteria andIdNotBetween(long value1, long value2) {
      addCriterion(IProjectServerRelateDAO.Id + " not between", value1, value2, "id");
      return this;
    }

    public Criteria andIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProjectServerRelateDAO.Id + " not between", value1, value2, "id");
      return this;
    }

    public Criteria andMiddleWareIdIsNull() {
      addCriterion(IProjectServerRelateDAO.MiddleWareId + " is null");
      return this;
    }

    public Criteria andMiddleWareIdIsNotNull() {
      addCriterion(IProjectServerRelateDAO.MiddleWareId + " is not null");
      return this;
    }

    public Criteria andMiddleWareIdIsNotEmpty() {
      addCriterion(
          IProjectServerRelateDAO.MiddleWareId
              + " is not null AND "
              + IProjectServerRelateDAO.MiddleWareId
              + " <> ''");
      return this;
    }

    public Criteria andMiddleWareIdIsEmpty() {
      addCriterion(
          "("
              + IProjectServerRelateDAO.MiddleWareId
              + " is null OR "
              + IProjectServerRelateDAO.MiddleWareId
              + " = '')");
      return this;
    }

    public Criteria andMiddleWareIdEqualTo(long value) {
      return andMiddleWareIdEqualTo(Long.valueOf(value));
    }

    public Criteria andMiddleWareIdEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.MiddleWareId + " = ", value, "middleWareId");
      return this;
    }

    public Criteria andMiddleWareIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.MiddleWareId);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andMiddleWareIdEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.MiddleWareId + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andMiddleWareIdNotEqualTo(long value) {
      return andMiddleWareIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andMiddleWareIdNotEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.MiddleWareId + " <>", value, "middleWareId");
      return this;
    }

    public Criteria andMiddleWareIdNotEqualToOrIsNull(long value) {
      return andMiddleWareIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andMiddleWareIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IProjectServerRelateDAO.MiddleWareId
              + " is null OR "
              + IProjectServerRelateDAO.MiddleWareId
              + " <>",
          value,
          "middleWareId");
      return this;
    }

    public Criteria andMiddleWareIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.MiddleWareId);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andMiddleWareIdNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.MiddleWareId + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andMiddleWareIdGreaterThan(long value) {
      return andMiddleWareIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andMiddleWareIdGreaterThan(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.MiddleWareId + " >", value, "middleWareId");
      return this;
    }

    public Criteria andMiddleWareIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.MiddleWareId);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andMiddleWareIdGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.MiddleWareId + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andMiddleWareIdGreaterThanOrEqualTo(long value) {
      return andMiddleWareIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andMiddleWareIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.MiddleWareId + " >=", value, "middleWareId");
      return this;
    }

    public Criteria andMiddleWareIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.MiddleWareId);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andMiddleWareIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.MiddleWareId + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andMiddleWareIdLessThan(long value) {
      return andMiddleWareIdLessThan(Long.valueOf(value));
    }

    public Criteria andMiddleWareIdLessThan(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.MiddleWareId + " <", value, "middleWareId");
      return this;
    }

    public Criteria andMiddleWareIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.MiddleWareId);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andMiddleWareIdLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.MiddleWareId + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andMiddleWareIdLessThanOrEqualTo(long value) {
      return andMiddleWareIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andMiddleWareIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.MiddleWareId + " <=", value, "middleWareId");
      return this;
    }

    public Criteria andMiddleWareIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.MiddleWareId);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andMiddleWareIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.MiddleWareId + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andMiddleWareIdIn(long[] values) {
      if (values.length == 1) {
        return andMiddleWareIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.MiddleWareId + " in", values, "middleWareId");
        return this;
      }
    }

    public Criteria andMiddleWareIdNotIn(long[] values) {
      if (values.length == 1) {
        return andMiddleWareIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.MiddleWareId + " not in", values, "middleWareId");
        return this;
      }
    }

    public Criteria andMiddleWareIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andMiddleWareIdEqualTo(values.get(0));
      } else {
        addCriterion(IProjectServerRelateDAO.MiddleWareId + " in", values, "middleWareId");
        return this;
      }
    }

    public Criteria andMiddleWareIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andMiddleWareIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IProjectServerRelateDAO.MiddleWareId + " not in", values, "middleWareId");
        return this;
      }
    }

    public Criteria andMiddleWareIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andMiddleWareIdEqualTo(values[0]);
      } else {
        addCriterion(
            IProjectServerRelateDAO.MiddleWareId + " in", Arrays.asList(values), "middleWareId");
        return this;
      }
    }

    public Criteria andMiddleWareIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andMiddleWareIdNotEqualTo(values[0]);
      } else {
        addCriterion(
            IProjectServerRelateDAO.MiddleWareId + " not in",
            Arrays.asList(values),
            "middleWareId");
        return this;
      }
    }

    public Criteria andMiddleWareIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.MiddleWareId + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andMiddleWareIdNotIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.MiddleWareId + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andMiddleWareIdBetween(long value1, long value2) {
      addCriterion(
          IProjectServerRelateDAO.MiddleWareId + " between", value1, value2, "middleWareId");
      return this;
    }

    public Criteria andMiddleWareIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(
          IProjectServerRelateDAO.MiddleWareId + " between", value1, value2, "middleWareId");
      return this;
    }

    public Criteria andMiddleWareIdNotBetween(long value1, long value2) {
      addCriterion(
          IProjectServerRelateDAO.MiddleWareId + " not between", value1, value2, "middleWareId");
      return this;
    }

    public Criteria andMiddleWareIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(
          IProjectServerRelateDAO.MiddleWareId + " not between", value1, value2, "middleWareId");
      return this;
    }

    public Criteria andProjectIdIsNull() {
      addCriterion(IProjectServerRelateDAO.ProjectId + " is null");
      return this;
    }

    public Criteria andProjectIdIsNotNull() {
      addCriterion(IProjectServerRelateDAO.ProjectId + " is not null");
      return this;
    }

    public Criteria andProjectIdIsNotEmpty() {
      addCriterion(
          IProjectServerRelateDAO.ProjectId
              + " is not null AND "
              + IProjectServerRelateDAO.ProjectId
              + " <> ''");
      return this;
    }

    public Criteria andProjectIdIsEmpty() {
      addCriterion(
          "("
              + IProjectServerRelateDAO.ProjectId
              + " is null OR "
              + IProjectServerRelateDAO.ProjectId
              + " = '')");
      return this;
    }

    public Criteria andProjectIdEqualTo(long value) {
      return andProjectIdEqualTo(Long.valueOf(value));
    }

    public Criteria andProjectIdEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.ProjectId + " = ", value, "projectId");
      return this;
    }

    public Criteria andProjectIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.ProjectId);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andProjectIdEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andProjectIdNotEqualTo(long value) {
      return andProjectIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andProjectIdNotEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.ProjectId + " <>", value, "projectId");
      return this;
    }

    public Criteria andProjectIdNotEqualToOrIsNull(long value) {
      return andProjectIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andProjectIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IProjectServerRelateDAO.ProjectId
              + " is null OR "
              + IProjectServerRelateDAO.ProjectId
              + " <>",
          value,
          "projectId");
      return this;
    }

    public Criteria andProjectIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.ProjectId);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andProjectIdNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andProjectIdGreaterThan(long value) {
      return andProjectIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andProjectIdGreaterThan(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.ProjectId + " >", value, "projectId");
      return this;
    }

    public Criteria andProjectIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.ProjectId);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andProjectIdGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andProjectIdGreaterThanOrEqualTo(long value) {
      return andProjectIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andProjectIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.ProjectId + " >=", value, "projectId");
      return this;
    }

    public Criteria andProjectIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.ProjectId);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andProjectIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andProjectIdLessThan(long value) {
      return andProjectIdLessThan(Long.valueOf(value));
    }

    public Criteria andProjectIdLessThan(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.ProjectId + " <", value, "projectId");
      return this;
    }

    public Criteria andProjectIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.ProjectId);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andProjectIdLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andProjectIdLessThanOrEqualTo(long value) {
      return andProjectIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andProjectIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IProjectServerRelateDAO.ProjectId + " <=", value, "projectId");
      return this;
    }

    public Criteria andProjectIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.ProjectId);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andProjectIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andProjectIdIn(long[] values) {
      if (values.length == 1) {
        return andProjectIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.ProjectId + " in", values, "projectId");
        return this;
      }
    }

    public Criteria andProjectIdNotIn(long[] values) {
      if (values.length == 1) {
        return andProjectIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.ProjectId + " not in", values, "projectId");
        return this;
      }
    }

    public Criteria andProjectIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andProjectIdEqualTo(values.get(0));
      } else {
        addCriterion(IProjectServerRelateDAO.ProjectId + " in", values, "projectId");
        return this;
      }
    }

    public Criteria andProjectIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andProjectIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IProjectServerRelateDAO.ProjectId + " not in", values, "projectId");
        return this;
      }
    }

    public Criteria andProjectIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andProjectIdEqualTo(values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.ProjectId + " in", Arrays.asList(values), "projectId");
        return this;
      }
    }

    public Criteria andProjectIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andProjectIdNotEqualTo(values[0]);
      } else {
        addCriterion(
            IProjectServerRelateDAO.ProjectId + " not in", Arrays.asList(values), "projectId");
        return this;
      }
    }

    public Criteria andProjectIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andProjectIdNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andProjectIdBetween(long value1, long value2) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " between", value1, value2, "projectId");
      return this;
    }

    public Criteria andProjectIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " between", value1, value2, "projectId");
      return this;
    }

    public Criteria andProjectIdNotBetween(long value1, long value2) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " not between", value1, value2, "projectId");
      return this;
    }

    public Criteria andProjectIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IProjectServerRelateDAO.ProjectId + " not between", value1, value2, "projectId");
      return this;
    }

    public Criteria andStatusIsNull() {
      addCriterion(IProjectServerRelateDAO.Status + " is null");
      return this;
    }

    public Criteria andStatusIsNotNull() {
      addCriterion(IProjectServerRelateDAO.Status + " is not null");
      return this;
    }

    public Criteria andStatusIsNotEmpty() {
      addCriterion(
          IProjectServerRelateDAO.Status
              + " is not null AND "
              + IProjectServerRelateDAO.Status
              + " <> ''");
      return this;
    }

    public Criteria andStatusIsEmpty() {
      addCriterion(
          "("
              + IProjectServerRelateDAO.Status
              + " is null OR "
              + IProjectServerRelateDAO.Status
              + " = '')");
      return this;
    }

    public Criteria andStatusEqualTo(String value) {

      addCriterion(IProjectServerRelateDAO.Status + " = ", value, "status");
      return this;
    }

    public Criteria andStatusEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Status);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Status + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusNotEqualTo(String value) {

      addCriterion(IProjectServerRelateDAO.Status + " <>", value, "status");
      return this;
    }

    public Criteria andStatusNotEqualToOrIsNull(String value) {

      addCriterion(
          IProjectServerRelateDAO.Status + " is null OR " + IProjectServerRelateDAO.Status + " <>",
          value,
          "status");
      return this;
    }

    public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Status);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Status + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusGreaterThan(String value) {

      addCriterion(IProjectServerRelateDAO.Status + " >", value, "status");
      return this;
    }

    public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Status);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Status + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusGreaterThanOrEqualTo(String value) {

      addCriterion(IProjectServerRelateDAO.Status + " >=", value, "status");
      return this;
    }

    public Criteria andStatusGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Status);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Status + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusLessThan(String value) {

      addCriterion(IProjectServerRelateDAO.Status + " <", value, "status");
      return this;
    }

    public Criteria andStatusLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Status);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Status + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusLessThanOrEqualTo(String value) {

      addCriterion(IProjectServerRelateDAO.Status + " <=", value, "status");
      return this;
    }

    public Criteria andStatusLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IProjectServerRelateDAO.Status);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Status + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProjectServerRelateDAO.Status + " like", buffer.toString(), "status");
      return this;
    }

    public Criteria andStatusNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IProjectServerRelateDAO.Status + " not like", buffer.toString(), "status");
      return this;
    }

    public Criteria andStatusIn(List<String> values) {

      if (values.size() == 1) {
        return andStatusEqualTo(values.get(0));
      } else {
        addCriterion(IProjectServerRelateDAO.Status + " in", values, "status");
        return this;
      }
    }

    public Criteria andStatusNotIn(List<String> values) {
      if (values.size() == 1) {
        return andStatusNotEqualTo(values.get(0));
      } else {
        addCriterion(IProjectServerRelateDAO.Status + " not in", values, "status");
        return this;
      }
    }

    public Criteria andStatusIn(String[] values) {

      if (values.length == 1) {
        return andStatusEqualTo(values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.Status + " in", Arrays.asList(values), "status");
        return this;
      }
    }

    public Criteria andStatusNotIn(String[] values) {
      if (values.length == 1) {
        return andStatusNotEqualTo(values[0]);
      } else {
        addCriterion(IProjectServerRelateDAO.Status + " not in", Arrays.asList(values), "status");
        return this;
      }
    }

    public Criteria andStatusIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Status + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IProjectServerRelateDAO.Status + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusBetween(String value1, String value2) {
      addCriterion(IProjectServerRelateDAO.Status + " between", value1, value2, "status");
      return this;
    }

    public Criteria andStatusNotBetween(String value1, String value2) {
      addCriterion(IProjectServerRelateDAO.Status + " not between", value1, value2, "status");
      return this;
    }
  }
}
